﻿
package com.ostrich.manpower.controller;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;

import com.base.page.Pager;
import com.base.util.HtmlUtil;
import com.base.web.BaseAction;
import com.ostrich.common.OstrichConstants;
import com.ostrich.manpower.bean.TostHrBaseinfo;
import com.ostrich.manpower.bean.TostHrDepartinfo;
import com.ostrich.manpower.bean.TostHrMealaddinfo;
import com.ostrich.manpower.bean.TostHrPersonyearinfo;
import com.ostrich.manpower.bean.TostHrSalaryinfo;
import com.ostrich.manpower.common.ImportUtil;
import com.ostrich.manpower.common.OstDateUtils;
import com.ostrich.manpower.service.impl.TostHrBaseinfoService;
import com.ostrich.manpower.service.impl.TostHrDepartinfoService;
import com.ostrich.manpower.service.impl.TostHrPersonyearinfoService;
import com.ostrich.manpower.service.impl.TostHrSalaryinfoService;
import com.ostrich.manpower.service.impl.TostHrSalaryinfoTService;
import com.ostrich.system.analysis.ParaminfoUtil;
import com.ostrich.system.bean.TostSysParaminfo;

/**
 * ClassName: Controller <br/>
 * date: 2013-5-9 下午03:07:38 <br/>
 * 
 * @author wangyinan
 * @version
 */
@Controller
@RequestMapping("/tostHrPersonyearinfo")
public class TostHrPersonyearinfoController extends BaseAction
{
	private final static Logger log= Logger.getLogger(TostHrPersonyearinfoController.class);

	// Servrice start
	@Autowired(required=false) //自动注入，不需要生成set方法了，required=false表示没有实现类，也不会报错。
	private TostHrPersonyearinfoService<TostHrPersonyearinfo> tostHrPersonyearinfoService; 
	@Autowired(required=false) //自动注入，不需要生成set方法了，required=false表示没有实现类，也不会报错。
	private TostHrDepartinfoService<TostHrBaseinfo> tosthrdepartinfoservice; 
	@Autowired(required=false) //自动注入，不需要生成set方法了，required=false表示没有实现类，也不会报错。
	private TostHrBaseinfoService<TostHrBaseinfo> tostHrBaseinfoService; 
	@Autowired
	TostHrSalaryinfoService<TostHrSalaryinfo> salaryservice;
	/**
	 * ilook 首页
	 * @param url
	 * @param classifyId
	 * @return
	 */
	@RequestMapping("/list")
	public ModelAndView  list(TostHrSalaryinfo tostHrSalaryinfo,HttpServletRequest request) throws Exception{
		Map<String,Object>  context = getRootMap();
//		List<TostHrSalaryinfo> dataList = salaryservice.queryByList(tostHrSalaryinfo);
//		//设置页面数据
//		context.put("dataList", dataList);
		return forword("manpower/tabTostHrPersonyearinfo",context); 
	}
	
	//查询公司
		@RequestMapping("/queryByhrCompany")
		public void queryByhrCompany(HttpServletResponse response){
			//获得id
			Map<Integer, TostSysParaminfo> cmps = ParaminfoUtil.getParamByPid(OstrichConstants.PARMHR_BASE_COMPANY);
			List<TostSysParaminfo> ls = new ArrayList<TostSysParaminfo>();
			for(Map.Entry<Integer, TostSysParaminfo> cp:cmps.entrySet()){
				ls.add(cp.getValue());
			}
			HtmlUtil.writerJson(response, ls);
		}
		//查询人员类别
		@RequestMapping("/queryByhrhrGrades")
		public void queryByhrhrGrades(HttpServletResponse response){
			Map<Integer, TostSysParaminfo> cmps = ParaminfoUtil.getParamByPid(OstrichConstants.PARMHR_BASE_PERGRADE);
			List<TostSysParaminfo> ls = new ArrayList<TostSysParaminfo>();
			for(Map.Entry<Integer, TostSysParaminfo> cp:cmps.entrySet()){
				ls.add(cp.getValue());
			}
			HtmlUtil.writerJson(response, ls);
		}
		
		//查询岗位名称
		@RequestMapping("/queryBypostname")
	      public void queryBypostname(HttpServletResponse response ){
			Map<Integer, TostSysParaminfo> cmps = ParaminfoUtil.getParamByPid(OstrichConstants.PARMHR_BASE_POSTNAME);
			List<TostSysParaminfo> ls = new ArrayList<TostSysParaminfo>();
			for(Map.Entry<Integer, TostSysParaminfo> cp:cmps.entrySet()){
				ls.add(cp.getValue());
			}
			HtmlUtil.writerJson(response, ls);
		}

		//查询部门名称
		@RequestMapping("/queryDepartId")
	         public void  queryDepartId(HttpServletResponse response){
			    List<TostHrDepartinfo> dataList =tosthrdepartinfoservice.queryDapart();
				HtmlUtil.writerJson(response, dataList);
			}
	
	/**
	 * json 列表页面
	 * @param url
	 * @param classifyId
	 * @return
	 * @throws Exception 
	 */
	@RequestMapping("/dataList") 
	public void  dataList(TostHrPersonyearinfo tostHrPersonyearinfo,HttpServletResponse response) throws Exception{
		List<TostHrPersonyearinfo> dataList = tostHrPersonyearinfoService.queryByList(tostHrPersonyearinfo);
		//设置页面数据
		Map<String,Object> jsonMap = new HashMap<String,Object>();
		jsonMap.put("total",tostHrPersonyearinfo.getPager().getRowCount());
		jsonMap.put("rows", dataList);
		HtmlUtil.writerJson(response, jsonMap);
	}
	/**
	 * 添加或修改数据
	 * @param url
	 * @param classifyId
	 * @return
	 * @throws Exception 
	 */
	
	@RequestMapping("/save")
	public void save(TostHrPersonyearinfo bean,Integer[] typeIds,HttpServletResponse response) throws Exception{
		bean.setHpeMonth(OstDateUtils.getDateByMonth(bean.getHpeMonth()));
		//Map<String,Object>  context = new HashMap<String,Object>();
		if(bean.getId()==null||StringUtils.isBlank(bean.getId().toString())){
			tostHrPersonyearinfoService.add(bean);
		}else{
			tostHrPersonyearinfoService.update(bean);
		}
		sendSuccessMessage(response, "保存成功~");
	}
	
	@RequestMapping("/getId")
	public void getId(Integer id,HttpServletResponse response) throws Exception{
		Map<String,Object>  context = getRootMap();
		TostHrPersonyearinfo bean  = tostHrPersonyearinfoService.queryById(id);
		if(bean  == null){
			sendFailureMessage(response, "没有找到对应的记录!");
			return;
		}
		context.put(SUCCESS, true);
		context.put("data", bean);
		HtmlUtil.writerJson(response, context);
	}
	
	@RequestMapping("/delete")
	public void delete(Integer[] id,HttpServletResponse response) throws Exception{
		tostHrPersonyearinfoService.delete(id);
		sendSuccessMessage(response, "删除成功");
	}
	@RequestMapping(value = "/upload", method = RequestMethod.POST)
	public ModelAndView upload(HttpServletRequest request,
			HttpServletResponse response, ModelMap model) throws IOException {
		MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		// 得到上传的文件
		MultipartFile mFile = multipartRequest.getFile("excelPath");
		// 得到上传服务器的路径
		String path = request.getSession().getServletContext()
				.getRealPath("/WEB-INF/upload/");
		// 得到上传的文件的文件名
		String filename = mFile.getOriginalFilename();
		InputStream inputStream = mFile.getInputStream();
		byte[] b = new byte[1048576];
		int length = inputStream.read(b);
		path += "\\" + filename;
		// 文件流写到服务器端
		FileOutputStream outputStream = new FileOutputStream(path);
		outputStream.write(b, 0, length);
		inputStream.close();
		outputStream.close();
		request.setAttribute("path",path);
		return new ModelAndView("forward:/TostHrPersonyearinfo/upimport.do");
	}
		
	@RequestMapping(value = "/upimport")
	public ModelAndView upimport(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		Map<String, Object> context = getRootMap();
		String filepath = (String) request.getAttribute("path");
		try {
			InputStream fis = new FileInputStream(filepath);
			HSSFSheet sh = ImportUtil.getSheet(fis);

			tostHrPersonyearinfoService.setPersonBySheet(sh);
			// Boolean mag = tostHrMealaddinfoService.test();
			// sendSuccessMessage(response, "导入成功~");
			request.setAttribute("success", "您已经导入成功请查看!");
			request.setAttribute("msg", "您已经导入成功请查看。");
			request.setAttribute("url", request.getContextPath()
					+ "/tostHrMealaddinfo/list.do");
		} catch (Exception e) {
			request.setAttribute("msg", "导入失败，请查看xls文件是否格式正确");
		}
		return forword("penmsg", context);
	}
	
}
